How to Import WhatsApp Contacts from Google Sheet to BotSailor

BotSailor now allows you to import WhatsApp contacts directly from Google Sheets making it easier than ever to manage your subscribers and launch powerful broadcast campaigns. In this guide, you’ll learn exactly how to connect your Google account, import sheets, map fields correctly, and build a clean, personalized contact list for your WhatsApp marketing.  For connecting google sheet with BotSailor please read this document here- How to Connect and Import Google Sheet

Checklist Before Importing

✅ Ensure your phone numbers are correctly formatted with country codes.
✅ Use clean, alphanumeric column headers.
✅ Double-check all field mappings during import.
✅ Test a few sample contacts first if needed.

Step 1: Import WhatsApp Contacts from Google Sheet

Once your Sheet is ready, now import the contacts:

• Go to WhatsApp → Subscriber Manager inside BotSailor.
• Click on Options.
• Select Import Subscribers.
• Choose Import from Google Sheet.
• Select the Google Sheet you want to use.
  
  
  

Step 2: Map Fields Correctly

After selecting the Sheet:

• BotSailor will show a sample preview of two data rows.
• Click Map Fields.
• Match your sheet columns to BotSailor fields:
• Map phone → Subscriber Phone (Mandatory)
• Map name → Subscriber Name
• Double-check each field mapping carefully.
  
  

 Proper mapping ensures data is stored correctly and used in personalization later.

Step 3: Confirm and Import

• After mapping, click Confirm.
• BotSailor will start importing your contacts.
• Once complete, all imported contacts will appear inside your WhatsApp Subscriber List.
  
  

Congratulations! Your WhatsApp contacts are now ready for broadcast, segmentation, and automation campaigns.

FAQs

Can I import contacts from any Google account?

No, you must first connect your Google account to BotSailor through Settings → Google Sheets and authorize access. Only Sheets from connected accounts can be imported.

What is the required format for the Google Sheet?

Sheet must have proper column headers (e.g., phone, name, email).
Column headers should be alphanumeric only no spaces or special characters.
Phone numbers must include country codes (e.g., +1 for USA, +91 for India).

Is the phone number field mandatory during import?

Yes. The phone number field is mandatory because it identifies WhatsApp subscribers inside BotSailor. Without it, the contact cannot be imported.

How do I find the Sheet ID to import an existing sheet?

The Sheet ID is part of the Google Sheet URL.
Example: In https://docs.google.com/spreadsheets/d/1AbcXYZ12345/edit, the ID is 1AbcXYZ12345.

Can I map additional fields like email, city, or interests?

Yes. During field mapping, you can assign additional columns from your Google Sheet to custom fields inside BotSailor.
This helps you personalize future broadcasts even more.

What happens if some fields are missing or wrongly mapped?

If fields are not mapped correctly:
Only the mapped fields will be imported.
Missing fields will be empty.

It’s highly recommended to review your mappings carefully before confirming the import.

Can I update an existing subscriber’s data through import?

No. Importing from Google Sheets in BotSailor only adds new subscribers.
It does not update existing contacts automatically. For updating, manual editing or automation setups would be needed.

Is there a limit on how many contacts I can import from a Sheet?

BotSailor allows bulk importing of contacts.
However, for best performance, it’s recommended to import sheets containing up to 5,000–10,000 rows per import.
For larger lists, break them into multiple sheets.

Can I automate updates from a Google Sheet to BotSailor?

Currently, imports from Google Sheets are a manual process (you initiate the import).
Live sync between Sheets and BotSailor is not available at the moment.

After import, how can I use the contacts?

Once imported, you can:
-Launch broadcasts to them immediately
-Add them into labels, sequences, or flow campaigns
-Personalize WhatsApp messages using dynamic fields like name, service interest, etc.